Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot

I’ve been running this blog on Hugo for a long time, and like most blogs with real history, it’s accumulated some tech debt. Some of it is my own...

New article – migrating from a named instance

Do you have a case where you have a named instance you'd like to migrate to a default instance? Is there pushback on doing so? Are there concerns that...

SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026

SQL Server gMSA: Why DBAs Still Aren't Using It in 2026

Group Managed Service Accounts (gMSAs) solve the classic service-account password problem - just look at...

Using the SIGN() Function: #SQLNewBlogger

I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where...

Demo for Parameter Sniffing and Memory Grant Feedback

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo subscription cost. This was meant for a private demo so I can learn more about...

Take Time to Gain Perspective

Probably the best piece of advice I ever received is to take time to gain perspective.

How I Troubleshoot a Slow SQL Server Live

No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different...

TRY_PARSE Limitations: #SQLNewBlogger

I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted their repro didn’t work, with no real comment. As...

SQL Server sa Account Security: Rename, Disable & Best Practices

SQL Server sa Account Security: Rename, Disable & Best Practices

In the Windows administration world, it's pretty much a standard practice to rename the local administrator...

Stanford Emerging Technology Review 2026 Report is out

Artificial Intelligence and quantum computing are two areas of emerging technology that receive most of the tech news. However, the Stanford Emerging Technology Review tries to include any relevant...